package com.itheima.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MemberMapper {
    Integer getMemberCountByMonths(String month);

    @Select("select count(id) from t_member where regTime = #{today}")
    Integer newMemberCountByDate(String today);
    
    @Select("select count(id) from t_member")
    Integer newMemberTotalCount();

    @Select("select count(id) from t_member where regTime > #{monday}")
    Integer newMemberCountByWeek(String monday);

    @Select("select count(id) from t_member where regTime > #{month}")
    Integer newMemberCountByMonth(String month);

}
